| FaMultipleRecAckWork |
| EntityType | Independent |
| Logical Entity Name | FaMultipleRecAckWork |
| Default Table Name | FaMultipleRecAckWork |
| Logical Only | NO |
| Definition | |
| Note |
| FaMultipleRecAckWork Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
FaMultipleRecAckWorkID |
INTEGER | NO | ||
| RecordType | CHAR(2) | YES | ||
| AwardYear | CHAR(7) | YES | ||
| BatchID | CHAR(26) | YES | ||
| RegPellID | CHAR(6) | YES | ||
| MRCode1 | CHAR(1) | YES | ||
| MRCode2 | CHAR(1) | YES | ||
| MRStudentID | CHAR(11) | YES | ||
| MRPellID | CHAR(6) | YES | ||
| SSN | CHAR(9) | YES | ||
| NameCode | CHAR(2) | YES | ||
| AttPellID | CHAR(6) | YES | ||
| InstName | CHAR(70) | YES | ||
| Addr1 | CHAR(35) | YES | ||
| Addr2 | CHAR(35) | YES | ||
| City | CHAR(25) | YES | ||
| State | CHAR(2) | YES | ||
| Zip | CHAR(9) | YES | ||
| FAAName | CHAR(30) | YES | ||
| FAAPhone | CHAR(10) | YES | ||
| FAAFax | CHAR(10) | YES | ||
| CHAR(50) | YES | |||
| PellGrant | CHAR(8) | YES | ||
| AwardAmount | CHAR(8) | YES | ||
| TranNumb | CHAR(2) | YES | ||
| EIC | CHAR(5) | YES | ||
| EnrollDate | CHAR(10) | YES | ||
| OrigCreateDate | CHAR(10) | YES | ||
| TotalDisbAccept | CHAR(8) | YES | ||
| LastActivityDate | CHAR(10) | YES | ||
| NextExpDisbDate | CHAR(10) | YES | ||
| EligUsed | CHAR(7) | YES | ||
| EdFlags | CHAR(10) | YES | ||
| DateAdded | DATETIME | YES | ||
| DateLstMod | DATETIME | YES | ||
| UserID | INTEGER | YES | ||
| StudentDOB | CHAR(10) | YES | ||
| StudentFirstName | CHAR(12) | YES | ||
| StudentLastName | CHAR(16) | YES | ||
| StudentMI | CHAR(1) | YES | ||
| CurrentSSN | CHAR(9) | YES | ||
| ts | TIMESTAMP/DATE | NO | ||
| AddlEligibilityInd | BIT | NO | ||
| LifetimeEligUsed | CHAR(8) | NO | ||
| Post911DVDInd | BIT | NO |
| FaMultipleRecAckWork Keys |
| Key Name | Key Type | Keys |
| FaMultipleRecAckWork_FaMultipleRecAckWorkID_U_C_IDX | PrimaryKey | FaMultipleRecAckWorkID |
| FaMultipleRecAckWork Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FaMultipleRecAckWork Check Constraints |
| Check Constraint Name | CheckConstraint |